# coding=utf-8
# 同级目录输入odpsddl.txt文件，输出mysqlddl.txt文件，可以将odps里面的建表语句改成mysql中的建表语句
read_file = open("odpsddl.txt", "r")
write_file = open("mysqlddl.txt", "w")
list = []
lines = read_file.readlines()
for line in lines:
    list.append(line)
for e in list:
    e = e.strip().replace("STRING", "VARCHAR(128)")
    write_file.write(e + "\n")
read_file.close()
write_file.close()
